package com.sxy.demo.sxy;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @Description: 商品渠道禁售表
 * @author: xzz
 * @Date: 2023/7/25
 */
@Data
@TableName("rms_activity_forbidden_goods")
/**
 *         SELECT
 *             *
 *         FROM rms_activity_forbidden_goods af
 *         where af.deleted = 0 and af.channel = #{channel}
 *         <if test="@cn.hutool.core.collection.CollUtil@isNotEmpty(spuIds)">
 *             and af.goods_spu_id in
 *             <foreach collection="spuIds" item="item" index="index" open="(" separator="," close=")">
 *                 #{item}
 *             </foreach>
 *         </if>
 *           and af.effective_time &lt;= now() and af.expired_time > now()
 */
public class ActivityForbiddenGoods extends BaseEntity implements Serializable {
    /**
     * 商品ID
     */
    private Long goodsSpuId;
    /**
     * spu编码
     */
    private String goodsSpuCode;
    /**
     * 生效时间
     */
    private Date effectiveTime;
    /**
     * 到期时间
     */
    private Date expiredTime;
    /**
     * 备注
     */
    private String remark;
    /**
     * 渠道：0-电商
     */
    private Integer channel;
}
